Labels:text | screenshot | diagram | number OCR: Warehouse Users Warehouse Metadata Tier 0 Tier 1 Tier 2 Tier 3 reach reach through through - staging area -centralized, mostly normalized - centralized, denormalized, and data marts and personal queried directly & reach-through multidimensional structures databases from Tier 2 and Tier 3 structures - queried directly & - queried directly Getting Data Out reach-through from Tier 3 Getting Data In Data Movement Restructure & & Cleansing Denormalize Restructure/ Denormalize/ Copy Data Loads/ Cleansing/ Integrate Internal & External Data FIGURE The four logical tiers of our data warehouse.
